/*
 * @Description: json数据转化成excel导出
 * @Author: zhanyinjia
 * @Date: 2022-11-15 13:34:47
 * @LastEditors: zhanyinjia
 * @LastEditTime: 2022-11-16 17:03:34
 */
// excel表头
const flatExcelHead = {
  sourceOrderNo: '源单编号',
  businessDate: '销售出库单业务日期',
  materialName: '物料名称',
  materialNo: '物料编码',
  spec: '规格型号',
  unit: '计价单位',
  materialUnitNumber: '计价数量',
  materialTaxUnitPrice: '含税单价',
  taxRate: '税率（%）',
  materialTaxMoney: '价税合计',
  billNo: '单据编号',
}
const flatExcelKeys = ['sourceOrderNo', 'businessDate', 'materialName', 'materialNo', 'spec', 'unit', 'materialUnitNumber', 'materialTaxUnitPrice', 'taxRate', 'materialTaxMoney', 'billNo']
// 平铺的普通数据
const flatJson = [
  {
    sourceOrderNo: 'XSCKD10106009430',
    businessDate: '2022/10/25',
    materialName: '五味子',
    materialNo: 'CP0001000003798',
    spec: '大包（TL）',
    unit: '千克',
    materialUnitNumber: '105.6',
    materialTaxUnitPrice: '76.66',
    taxRate: '9',
    materialTaxMoney: '8095.3',
    billNo: 'AR00049101',
  },
  {
    sourceOrderNo: 'CFSS8547',
    businessDate: '2022/09/18',
    materialName: '大枣',
    materialNo: 'CP0001000003798',
    spec: '大包（TL）',
    unit: 'Kg',
    materialUnitNumber: '105.6',
    materialTaxUnitPrice: '76.66',
    taxRate: '9',
    materialTaxMoney: '955.3',
    billNo: 'AR00049101',
  },
  {
    sourceOrderNo: 'ADEZ14557852255',
    businessDate: '2022/10/21',
    materialName: '重楼',
    materialNo: 'CP0001000003798',
    spec: '大包（TL）',
    unit: '千克',
    materialUnitNumber: '105.6',
    materialTaxUnitPrice: '76.66',
    taxRate: '9',
    materialTaxMoney: '1847.3',
    billNo: 'AR00049101',
  }
]


export {
  flatExcelHead,
  flatExcelKeys,
  flatJson
}